<?php require_once('../connections/con_gl.php'); ?>
<?php
$getquerycheckinout = str_replace("+"," ",$_GET[query_checkinout]);
mysql_select_db($database_con_gl, $con_gl);


$mulai = $_GET['mulai'];
$akhir = $_GET['akhir'];    
	
mysql_select_db($database_con_gl, $con_gl);
$query_datacheckinout = $getquerycheckinout;
$cekdatacheckinout= mysql_query($query_datacheckinout, $con_gl) or die(mysql_error());
$row_datacheckinout = mysql_fetch_assoc($cekdatacheckinout);
$totalRows_korporate = mysql_num_rows($cekdatacheckinout);

mysql_select_db($database_con_gl, $con_gl);
$query_getcompany = "SELECT * FROM gl_company WHERE id = 1";
$getcompany = mysql_query($query_getcompany, $con_gl) or die(mysql_error());
$row_getcompany = mysql_fetch_assoc($getcompany);
$totalRows_getcompany = mysql_num_rows($getcompany);
?>
<style type="text/css">
<!--
.style2 {font-size: 18px}
-->
</style>

<P align="center"><span class="style2"><strong>CIPAGANTI RENTAL CAR & TRAVEL</strong></span></P>
<P align="center" class="style2"><strong>LAPORAN CHECK IN & OUT KENDARAAN</strong></P>
<br />
<p align="left"></P>
<p align="left">&nbsp;</P>
<table width="100%" border="0" cellpadding="4" cellspacing="0" bordercolor="#000000">
<tr>
</tr>
 <tr>
   <th width="200">CABANG : <?php echo $row_datacheckinout['gudang']; ?></th>
   <th width="78">&nbsp;</th>
    <th width="100">&nbsp;</th>
	<th width="80">&nbsp;</th>
	<th width="300">&nbsp;</th>
	<th width="300">&nbsp;</th>
	<th width="300">&nbsp;</th>
	<th width="300">&nbsp;</th>
	<th width="100">&nbsp;</th>
	<th width="100">&nbsp;</th>
	<th width="250">&nbsp; </th>    
    <th width="100" align="center"></th>
    <th width="100" align="center"></th>
    <th width="100" align="center">PERIODE : <?php echo $mulai.'-'.$akhir ?></th>
</table>
<table width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#000000">
    <tr bgcolor="#CCCCCC">
      <th width="78" rowspan="3"><strong>No</strong></th>
      <th width="100" rowspan="3"><strong>No  Order</strong></th>
    <th width="100" rowspan="3">Customer</th>
	<th width="80" rowspan="3">No. Kendaraan</th>
	<th width="300" rowspan="3">Alamat</th>
	<th width="100" rowspan="3">Supir</th>
	<th colspan="4">Check Out<strong></strong></th>
	<th colspan="4" align="center">Check In</th>
	<th width="100" rowspan="3" align="center"><strong>Keterangan</strong></th>
  </tr>
    <tr bgcolor="#CCCCCC">
      <th colspan="2">Rencana</th>
      <th colspan="2" align="center">Realisasi</th>
      <th colspan="2" align="center">Rencana</th>
      <th colspan="2" align="center">Realisasi</th>
    </tr>
    <tr bgcolor="#CCCCCC">
      <th width="100">Tanggal</th>
      <th width="250">Jam</th>
      <th width="100" align="center">Tanggal</th>
      <th width="100" align="center">Jam</th>
      <th width="100" align="center">Tanggal</th>
      <th width="100" align="center">Jam</th>
      <th width="100" align="center">Tanggal</th>
      <th width="100" align="center">Jam</th>
    </tr>
	    
        <?php $i = 1;do { ?>
        <tr valign="top">
          <td align="left"><?php echo $i;?></td>
          <td align="left"><?php echo $row_datacheckinout['kendaraan']; ?></td>
          <td align="left"><?php echo $row_datacheckinout['nama']; ?></td>
          <td><?php echo $row_datacheckinout['kendaraan']; ?></td>
          <td><?php echo $row_datacheckinout['alamat']; ?></td>
          <td><?php echo $row_datacheckinout['driver']; ?></td>
          <td><?php echo $row_datacheckinout['tglcheckin'];?></td>
          <td><?php echo $row_datacheckinout['jamcheckin']; ?></td>
          <td><?php echo $row_datacheckinout['rtglcheckin'];?></td>
          <td><?php echo $row_datacheckinout['rjamcheckin']; ?></td>
          <td><?php echo $row_datacheckinout['tglcheckout'];?></td>
          <td><?php echo $row_datacheckinout['jamcheckout']; ?></td>
          <td><?php echo $row_datacheckinout['tglcheckout'];?></td>
          <td><?php echo $row_datacheckinout['rjamcheckout']; ?></td>
          <td><?php echo $row_datacheckinout['rjamcheckout']; ?></td>
          
        </tr>
			<?php 
			$i++;
        } while ($row_datacheckinout = mysql_fetch_assoc($cekdatacheckinout)); 
		?>
        
</table>
  
  
